If I'm reading the docs correctly, I should be able to write:
ALTER TABLE mytable ADD ptr INT4 REFERENCES othertable ON DELETE SET NULL
but when I look in pg_constraint table (pg 7.3) I don't see any kind
of foreign key constraint.
BTW, are the PDF versions of the 7.3 Docs? I only see 7.2 on the web site.
Thanks!
John DeSoi, Ph.D.